FundSourceLendingInstitution 
EntityType  Dependent 
Logical Entity Name  FundSourceLendingInstitution 
Default Table Name  FaFundSourceBanks 
Logical Only  NO 
Definition 
 
Note 
 

FundSourceLendingInstitution Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Id    INTEGER  NO 
 
FundSourceId(PK)(FK)    INTEGER  NO 
 
CampusId(PK)(FK)    INTEGER  NO 
 
LenderLendingInstitutionId(FK)    INTEGER  YES 
 
ServicerLendingInstitutionId(FK)    INTEGER  YES 
 
GuarantorLendingInstitutionId(FK)    INTEGER  YES 
 
LastModifiedUserId(FK)    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 

FundSourceLendingInstitution Keys 
Key Name  Key Type  Keys 
FaFundSourceBanks_UserID_N_N_IDX  Inversion Entry  LastModifiedUserId 
FaFundSourceBanks_ServicerFaLenderID_N_N_IDX  Inversion Entry  ServicerLendingInstitutionId 
FaFundSourceBanks_LenderFaLenderID_N_N_IDX  Inversion Entry  LenderLendingInstitutionId 
FaFundSourceBanks_GuarantorFaLenderID_N_N_IDX  Inversion Entry  GuarantorLendingInstitutionId 
FaFundSourceBanks_FaFundSourceBanksID_U_N_IDX  Unique Constraint  Id 
FaFundSourceBanks_FaFundSourceID_SyCampusID_U_C_IDX  PrimaryKey  FundSourceId, CampusId 

FundSourceLendingInstitution Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
FundSource  Identifying  One To Zero or More        FundSourceId  NO 
LendingInstitution  Non-Identifying  Zero or One to Zero or More        GuarantorLendingInstitutionId  NO 
LendingInstitution  Non-Identifying  Zero or One to Zero or More        LenderLendingInstitutionId  NO 
LendingInstitution  Non-Identifying  Zero or One to Zero or More        ServicerLendingInstitutionId  NO 
Campus  Identifying  One To Zero or More        CampusId  NO 
Staff  Non-Identifying  One To Zero or More        LastModifiedUserId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

FundSourceLendingInstitution Check Constraints 
Check Constraint Name  CheckConstraint